package com.yangjun.dao.mybatis.mapper.businessAnalysis;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.yangjun.entity.businessAnalysis.SemConversionEntity;

public interface SemConversionMapper {
	
	List<SemConversionEntity> querySiteDayFlow(@Param(value="dateArr") String[] dateArr,@Param(value="siteid") String siteid); 
	
	List<SemConversionEntity> querySiteChannelSourceKeywordHourFlow(@Param(value="siteid") String siteid,@Param(value="channel") String channel,@Param(value="sourceKeyword") String sourceKeyword,@Param(value="dateArr")String[] dateArr); 

	List<SemConversionEntity> querySiteHourActionNetamt(@Param(value="siteid") String siteid,@Param(value="action") String action,@Param(value="dateArr")String[] dateArr); 

	List<SemConversionEntity> queryChannelTable(@Param(value="siteid") String siteid,@Param(value="date") String date,@Param(value="orderSql") String orderSql); 
	
	List<SemConversionEntity> querySourceKeywordTable(@Param(value="siteid") String siteid,@Param(value="date") String date,@Param(value="channel") String channel,@Param(value="orderSql") String orderSql); 

	List<SemConversionEntity> queryChannelSourceKeywordTable(@Param(value="siteid") String siteid,@Param(value="date") String date,@Param(value="channel") String channel,@Param(value="sourceKeyword") String sourceKeyword); 

	List<SemConversionEntity> queryProvincePie(@Param(value="siteid") String siteid,@Param(value="date") String date); 
	
	List<SemConversionEntity> queryHourPie(@Param(value="siteid") String siteid,@Param(value="date") String date); 
	
	List<SemConversionEntity> queryHotSalesWares(@Param(value="siteid") String siteid,@Param(value="date") String date,@Param(value="channel") String channel,@Param(value="orderSql") String orderSql); 
	
	void  deleteSemRealtimeSalesByBeforeDate(@Param(value="date") String date); 
	void  deleteSemRealtimeChannelByBeforeDate(@Param(value="date") String date); 


	
}
